UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bZRJOGQK/gj+q7JLCpE5YA62VzmmzqywoCbIAmfARCw='
WHERE
key_id = 'd0e47cfb95b26436b1d30893bcdcbf2608020544e49ef3d961aabc92d61504f9'
AND (
token = 'bZRJOGQK/gj+q7JLCpE5YA62VzmmzqywoCbIAmfARCw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)