UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/KRxvS3r9+oh+bYbUBNKb92taoAWrMdsY0al4LNwGG0='
WHERE
key_id = '7a563645c76e672c76199c06e1ae943f4f26f4ae91bcecbebc1775add4e8f771'
AND (
token = '/KRxvS3r9+oh+bYbUBNKb92taoAWrMdsY0al4LNwGG0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)