UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '//6gpFWJ5XZoXgrk70Q7UWig9E3nuEY6/axq+8WOIOw='
WHERE
key_id = '70df4d572ea09ed8ea400607be4af70ff9d3ca217bee2622e15fb1a87b14a60c'
AND (
token = '//6gpFWJ5XZoXgrk70Q7UWig9E3nuEY6/axq+8WOIOw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)