UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5WCG4eqFeOZzEPngZNGcW0FiFEPqySixAPX4Uv+T9b0='
WHERE
key_id = '67659baf3a3075c0013a4b5f3fee3fc654eab2bc818ae600b3059fe174799f97'
AND (
token = '5WCG4eqFeOZzEPngZNGcW0FiFEPqySixAPX4Uv+T9b0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)