UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'CFksVMjT0w17r4We5V2FxrzNss9yCFPJHZlv1FICI3c='
WHERE
key_id = '4193df2a822e266c3d3255098c6de4962a057209d92c81cfe1bb88bc49065414'
AND (
token = 'CFksVMjT0w17r4We5V2FxrzNss9yCFPJHZlv1FICI3c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)