UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lKv7L0FW77DP03wy+XJt0CfN7tcFqeA2Q+cyZCSi8TU='
WHERE
key_id = '1a12b27588fc806fd25489da2e4399628d11b531a4352d9607170aa67cd20a50'
AND (
token = 'lKv7L0FW77DP03wy+XJt0CfN7tcFqeA2Q+cyZCSi8TU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)