UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lgm1igKKT+98bg5xlna95WZQCKMS2J+xoHLzCr9TMQg='
WHERE
key_id = 'c0f478fef446ea7a5f4a8219565aad135d85604db1c38ff749f4be1c4a9f1cb2'
AND (
token = 'lgm1igKKT+98bg5xlna95WZQCKMS2J+xoHLzCr9TMQg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)