UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Px2YbYYcWN0joA0BC+KiwcxwXx7xBLoelQ5fV75Q+k8='
WHERE
key_id = 'd27dcc30d7cc1ca4ab71d3c1939624585e7ace9b0e9c9539d0b8b3f251676656'
AND (
token = 'Px2YbYYcWN0joA0BC+KiwcxwXx7xBLoelQ5fV75Q+k8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)