UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6WPnnITvLboIPxCJ8dEeSQaRZeR8jyjAYDNARAUJFps='
WHERE
key_id = 'fa0b648a5d6d11a4c32a5e61236eb3207e0e933a314a6e8058ab7c696774ca30'
AND (
token = '6WPnnITvLboIPxCJ8dEeSQaRZeR8jyjAYDNARAUJFps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)