UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'E4aweCVFV0nKg8UbwANf/f91iMoHLDlMN4XNJo+NHOY='
WHERE
key_id = '3312191b8f9e2562b1424624a6274b8edf363003a37a841cf1f566aa72b2ebf3'
AND (
token = 'E4aweCVFV0nKg8UbwANf/f91iMoHLDlMN4XNJo+NHOY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)