UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'deE6Os+aCt3mfb0FNo9vVAe7RtYshWsrL+sBY6l5R8g='
WHERE
key_id = 'e14d7298f15f8bf8e6552886d342fd7252d8a982405566bc86eff3f8b5ef39a5'
AND (
token = 'deE6Os+aCt3mfb0FNo9vVAe7RtYshWsrL+sBY6l5R8g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)