UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'NwETaTl08lhRC9Fd6RNCbcgGQMNoN45E1L0mAWvGpDs='
WHERE
key_id = '1e0dd7ec4f1b72c1205259c55c4af659673dcff5856c7c3328b593da98340337'
AND (
token = 'NwETaTl08lhRC9Fd6RNCbcgGQMNoN45E1L0mAWvGpDs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)