UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '72lqCL5r0pTgu+0F9iD2KOCKU/5p6FYrB3OPLDanZqw='
WHERE
key_id = 'ef0ffebcd5650051363060b1df643a2f92c20119358e32a90e65e31151b07f7a'
AND (
token = '72lqCL5r0pTgu+0F9iD2KOCKU/5p6FYrB3OPLDanZqw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)