UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z2EP+2LL7lovkFWwKyE0K2xhFgw/K4ShidFu3ip3TWc='
WHERE
key_id = '09191274a5d8748a75c892e966202cc2db7a8651bc44ff66ea12df087ca595f8'
AND (
token = 'z2EP+2LL7lovkFWwKyE0K2xhFgw/K4ShidFu3ip3TWc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)