UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '+12ClcGX0fH0i43vTKnqQl36DCmrrJb9Y2cZzDDcB/A='
WHERE
key_id = 'd0077e29df107fb7719dde95e37d52d03831cc5e2075c1c0717c8e73565a0517'
AND (
token = '+12ClcGX0fH0i43vTKnqQl36DCmrrJb9Y2cZzDDcB/A='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)