UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'n6zLRvpUOhYjYLASvS4tRLif6svfwYj2QnklKXudp0g='
WHERE
key_id = '7e2994e34e842c0914e9709e0a6ce39137122d77c78fb209bfc19ebb64c10638'
AND (
token = 'n6zLRvpUOhYjYLASvS4tRLif6svfwYj2QnklKXudp0g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)