UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/XVYnsHSMJAZ/ENq/9/875I9WRbwSg5v95mmRxl+Qb4='
WHERE
key_id = '86b138e228ae16c8378d31411c170cf543d239b7d2b74b2f51df69ce72783480'
AND (
token = '/XVYnsHSMJAZ/ENq/9/875I9WRbwSg5v95mmRxl+Qb4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)