UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7pB+Yrgnei4tCHlDWcAKUQDapBFHLpL/9k3SCPzSrH8='
WHERE
key_id = '8df40a9f4f9a504d065c8ca971d2531b79bf3d9d01f3b049a679c72a5cecdc9c'
AND (
token = '7pB+Yrgnei4tCHlDWcAKUQDapBFHLpL/9k3SCPzSrH8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)